Problem Note 32035: The INDTD_PUBLISH_FORMATS macro does not respond when it contains large numbers of format categories that you are publishing to Teradata
 |  |  |  |
The INDTD_PUBLISH_FORMATS macro used to load user written formats into Teradata can hang. The problem will most likely occurs when the format contains several thousand categories.
The problem occurs because the INDTD_PUBLISH_FORMATS macro uses a FILENAME pipe call to Teradata BTEQ to load the formats into the Teradata database. When there are a lot of format categories the FILENAME PIPE command to BTEQ can time-out before the format categories load into Teradata. The time-out value is set by the SAS environment variable SAS_UPIPE_PROCESS_TIMEOUT which is set by default to 120000 milliseconds, or two minutes.
To circumvent the problem you need to increase the time-out when invoking SAS as follows:
sas -set SAS_UPIPE_PROCESS_TIMEOUT 600000
In the example above, this would set the time-out value to 5 minutes.
The -set command can also be added to the SASV9.CFG file.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Teradata | Microsoft Windows XP Professional | 9.2 TS2M0 | 9.2 TS2M2 |
| Windows Vista | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2009-10-21 12:43:09 |
| Date Created: | 2008-05-07 17:46:25 |